﻿<%@ Page Title="" Language="C#" MasterPageFile="~/Site.Master" AutoEventWireup="true" CodeBehind="SqlDataAdapterExample.aspx.cs" Inherits="ShoppingApp.SqlDataAdapterExample" %>
<asp:Content ID="Content1" ContentPlaceHolderID="HeadContent" runat="server">
</asp:Content>
<asp:Content ID="Content2" ContentPlaceHolderID="MainContent" runat="server">

    <p>
        <br />
        <asp:Button ID="GetDataSqlCommandButton" runat="server" Font-Size="XX-Small" 
            Height="34px" onclick="GetDataSqlCommandButton_Click" 
            Text="Get Data SqlCommand" Width="118px" />
        <br />
        <asp:Button ID="GetDataButton" runat="server" onclick="GetDataButton_Click" 
            Text="Get Data" />
        <asp:Button ID="Button1" runat="server" onclick="Button1_Click" 
            style="position: relative; top: 31px; left: 601px; width: 130px" 
            Text="Get With Schema" />
        <asp:Button ID="Button2" runat="server" onclick="Button2_Click" 
            style="position: relative; top: 78px; left: 450px; width: 152px" 
            Text="Submit With Schema" />
    </p>
    <div style="position: absolute">
        <asp:Button ID="SynchronizeButton" runat="server" 
            style="position: relative; top: -5px; left: 419px;" Text="Synchronize" 
            onclick="SynchronizeButton_Click" />
        <asp:TextBox ID="NameTextBox" runat="server" 
            style="position: relative; top: 50px; left: 176px"></asp:TextBox>
            
        <br />
        <asp:TextBox ID="ChainNameTextBox" runat="server" 
            style="position: relative; top: 61px; left: 282px"></asp:TextBox>
        <br />
        <asp:TextBox ID="CityTextBox" runat="server" 
            style="position: relative; top: 76px; left: 283px"></asp:TextBox>
        <br />
        <asp:TextBox ID="StreetTextBox" runat="server" 
            style="position: relative; top: 91px; left: 283px"></asp:TextBox>
        <br />
        
    </div>    
        
    <div style="position: absolute">
        <asp:Label ID="Label1" runat="server" Text="Insert new data:" 
            style="z-index: 1; left: 286px; top: 9px; position: absolute; width: 146px"></asp:Label>
        <asp:Label ID="Label3" runat="server" Text="ChainName:" 
            
            style="z-index: 1; left: 196px; top: 91px; position: absolute; height: 17px;"></asp:Label>
        <asp:Label ID="Label4" runat="server" Text="City:" 
            style="z-index: 1; left: 238px; top: 124px; position: absolute"></asp:Label>
        <asp:Label ID="Label5" runat="server" Text="Street:" 
            style="z-index: 1; left: 222px; top: 160px; position: absolute"></asp:Label>
        <asp:Label ID="Label2" runat="server" Text="Name:" 
            style="z-index: 1; left: 227px; top: 49px; position: absolute"></asp:Label>
    </div>
                
        <br />
        <br />
        <br />
        <br />
        <br />
        <br />
        
        <br />
    <br />
        <br />
    <br />
        <br />

        <div style="position: absolute">
        <asp:Button ID="SubmitButton" runat="server" 
            Text="Submit" onclick="SubmitButton_Click" 
                style="position: relative; top: 2px; left: 205px" />
        <asp:Button ID="InsertSqlCommandButton" runat="server" 
            onclick="InsertSqlCommandButton_Click" 
            Text="Insert using SqlCommand" 
                style="position: relative; top: 2px; left: 218px" />
        <asp:Button ID="InsertUsingStoredProcedureButton" runat="server" 
            onclick="InsertUsingStoredProcedureButton_Click" 
            Text="Insert using stored procedure" 
                style="position: relative; top: 2px; left: 232px" />
        
        </div>
        <br />
        <br />
        <br />

        
</asp:Content>
